Temp-tables used by General Manager
The General Manager uses several temp-tables to cache frequently needed information.
The General Manager uses the temp-tables described in Table 4–2 to cache information about users and filter sets. The ttUser temp-table is a copy of the Repository gsm_user table.
Table 4–2: Temp-table defined in af\app\afgenmngrp.i
|
Temp-table
|
Fields
(data types)
|
|
ttUser
|
user_obj (Decimal)
user_category_obj (Decimal)
user_full_name (Character)
user_login_name (Character)
user_creation_date (Date)
user_creation_time (Integer)
profile_user (Logical)
created_from_profile_user_obj (Decimal)
external_userid (Integer)
user_password (Character)
password_minimum_length (Integer)
password_preexpired (Logical)
password_fail_count (Integer)
password_fail_date (Date)
password_fail_time (Integer)
password_creation_date (Date)
password_creation_time (Integer)
password_expiry_date (Date)
password_expiry_time (Integer)
update_password_history (Logical)
check_password_history (Logical)
last_login_date (Date)
last_login_time (Integer)
disabled (Logical)
language_obj (Decimal)
password_expiry_days (Integer)
maintain_system_data (Logical)
default_login_company_obj (Decimal)
user_email_address (Character)
development_user (Logical)
security_group (Logical)
default_security_group (Logical)
|
|
ttFilterSetClause
|
filter_set_code (Character)
entity_list (Character)
buffer_list (Character)
additional_arguments (Character)
filter_set_clause (Character)
|
The General Manager also uses the temp-tables described in Table 4–3 to store information about entity display fields and entity mnemonics. These temp-tables are defined, respectively, like the Repository’s gsc_entity_display_field and gsc_entity_mnemonic tables with additional fields. The ttEntityMap temp-table is a copy of the ttEntityMnemonic temp-table.
Table 4–3: Temp-table defined in af\app\gsttenmn.i
|
Temp-table
|
Fields
(data types)
|
|
ttEntityDisplayField
|
entity_display_field_obj (Decimal)
entity_mnemonic (Character)
display_field_name (Character)
display_field_order (Integer)
display_field_label (Character)
display_field_column_label (Character)
display_field_format (Character)
display_field_datatype (Character)
|
|
ttEntityMnemonic
&
ttEntityMap
|
entity_mnemonic (Character)
entity_mnemonic_short_desc (Character)
entity_mnemonic_description (Character)
auto_properform_strings (Logical)
entity_mnemonic_label_prefix (Character)
entity_mnemonic_obj (Character)
entity_description_field (Character)
entity_description_procedure (Character)
entity_narration (Character)
entity_object_field (Character)
table_has_object_field (Logical)
entity_key_field (Character)
table_prefix_length (Integer)
field_name_separator (Character)
auditing_enabled (Logical)
version_data (Logical)
deploy_data (Logical)
entity_dbname (Character)
replicate_entity_mnemonic (Character)
replicate_key (Character)
scm_field_name (Character)
reuse_deleted_keys (Logical)
hasAudit (Logical)
hasComment (Logical)
hasAutoComment (Logical)
|
Table 4–4 describes the temp-table defined in af\app\gsmstttcch.i, which is used to cache status information.
Table 4–4: Temp-table defined in af\app\gsmstttcch.i
|
Temp-table
|
Fields
(data types)
|
|
ttStatusCache
|
tStatusObj (Decimal)
tCategoryType (Character)
tCategoryGroup (Character)
tCategorySubGroup (Character)
tStatusShortDesc (Character)
tStatusDescription (Character)
tStatusTLA (Character)
|